import openpyxl

wb = openpyxl.Workbook()
ws = wb.active
ws.title = '成绩单'
ws.sheet_properties.tabColor = "000000"
infos = [['姓名', '语文', '数学', '英语'], ['张三', 78, 98, 87], ['李四', 98, 68, 97], ['王五', 82, 82, 88]]
for i in range(len(infos)):
    ws[f'A{i+1}'] = infos[i][0]
    ws[f'B{i+1}'] = infos[i][1]
    ws[f'C{i+1}'] = infos[i][2]
    ws[f'D{i+1}'] = infos[i][3]

wb.save('./a.xlsx')
